SMFCSD Salaries Report

CAUTION There are three kinds of lies: lies, damned lies, and statistics.
In [1]:
import cufflinks as cf
import pandas as pd
import numpy as np

import plotly.offline as py
import plotly.graph_objs as go

from IPython.display import display, Markdown, Latex

py.init_notebook_mode(connected=True)

cf.set_config_file(offline=True)

pd.options.display.float_format = '{:20,.2f}'.format
In [2]:
# main data-frame init

dtype = {'County': np.str,
         'Employee Name': np.str,
         'Job Title': np.str,
         'Year': np.int64,
         'Notes': np.str,
         'Agency': np.str,
         'Status': np.str}


def to_float(x):
    try:
        return float(x)
    except Exception as e:
        return None


converters = {'Base Pay': to_float,
              'Overtime Pay': to_float,
              'Other Pay': to_float,
              'Benefits': to_float,
              'Total Pay': to_float,
              'Total Pay & Benefits': to_float}

df = pd.read_csv("data.csv.gz", compression='gzip', dtype=dtype, converters=converters)
In [3]:
# definitions

ENTITIES_MAPPING = {
    'Teachers': '(?i)teacher',
    'Managers': '(?i)principal|director|chief|intendent',
    'Superintendents': '(?i)superintendent'
}
ENTITIES = ['Teachers', 'Managers', 'Superintendents']
YEARS = [2016, 2015, 2014, 2013, 2012]
COUNTIES = ['San Mateo County']
HIGHLIGHT_AGECNY = 'San Mateo-Foster City'

def get_df(county, entity, year):
    return df[(df['County'] == county) & 
              (df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) & 
              (df['Year'] == year)] 

def display_mean_salary_by_year(county, entity, year):
    ga = get_df(county, entity, year).groupby(['Agency'])['Total Pay & Benefits']
    ga_mean = ga.mean()
    ga_mean = ga_mean.to_frame().reset_index().sort_values(by='Total Pay & Benefits', ascending=False)
    
   
    bar = go.Bar(x=ga_mean['Agency'],
                 y=ga_mean['Total Pay & Benefits'],
                 marker=dict(color=np.where(ga_mean['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
    layout = go.Layout(
        margin=go.Margin(
            l=60,
            r=50,
            b=150,
            t=100,
            pad=2
        ),
        title='{county}, {entity}, Mean Salary - {year}'.format(county=county, 
                                                                entity=entity, 
                                                                year=year),
        xaxis=dict(
            title='Agency',
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        ),
        yaxis=dict(
            title='Mean Salary (USD)',
            titlefont=dict(
                size=16,
                color='rgb(107, 107, 107)'
            ),
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        )
    )
    fig = go.Figure(data=[bar], layout=layout)
    py.offline.iplot(fig, filename='basic-bar')
    
    """    
    ga_mean.iplot(title='{county}, {entity}, Mean Salary - {year}'.format(county=county, 
                                                                          entity=entity, 
                                                                          year=year), 
                  x='Agency', kind='bar', filename='cufflinks/grouped-bar-chart',
                  xTitle='Agencies', yTitle='Mean Salary', colors={'Agency': 'red', 'Total Pay & Benefits': 'black'})
    """
    
    # print table under graph
    ga_descr = ga.describe()  
    #ga_descr[ga_descr.columns] = ga_descr[ga_descr.columns].fillna(0).astype(np.int64)   
    display(ga_descr.sort_values(by='mean', ascending=False))

    
def display_cumul_salary_change(county, entity, year_from, year_to):
    dt = df[(df['County'] == county) & 
              (df['Job Title'].str.contains("{entity}".format(entity=ENTITIES_MAPPING[entity]))) & 
              ((df['Year'] == year_from) | (df['Year'] == year_to))]
    dt = dt.groupby(['Agency', 'Year'])['Total Pay & Benefits'].mean().to_frame().reset_index()    
    dt = dt.pivot_table(columns=['Year'], values='Total Pay & Benefits', index=['Agency']).reset_index()
    dt.columns = ['Agency', 'year_from', 'year_to'] # because numbers in column names doesn't work
    dt['diff'] = dt.apply(lambda row: (row['year_to'] - row['year_from']) * 100 / row['year_from'], axis=1)
    dt = dt[(dt['diff'].notnull())]
    dt = dt.sort_values(by='diff', ascending=False)
   
    bar = go.Bar(x=dt['Agency'],
                 y=dt['diff'],
                 marker=dict(color=np.where(dt['Agency'] == HIGHLIGHT_AGECNY, 'rgba(222,45,38,0.8)', 'rgba(204,204,204,1)').tolist()))
    layout = go.Layout(
        margin=go.Margin(
            l=60,
            r=50,
            b=150,
            t=100,
            pad=2
        ),
        title='{county}, {entity}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county, 
                                                                entity=entity, 
                                                                year_from=year_from,
                                                                year_to=year_to),
        xaxis=dict(
            title='Agency',
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        ),
        yaxis=dict(
            title='Salary Change (%)',
            titlefont=dict(
                size=16,
                color='rgb(107, 107, 107)'
            ),
            tickfont=dict(
                size=14,
                color='rgb(107, 107, 107)'
            )
        )
    )
    fig = go.Figure(data=[bar], layout=layout)
    py.offline.iplot(fig, filename='basic-bar')
In [4]:
# Salary change

year_from = min(YEARS)
year_to = max(YEARS)

for county in COUNTIES:
    display(Markdown('# {county}, Cumulative Mean Salary Change in {year_from} - {year_to}'.format(county=county,
                                                                                              year_from=year_from,
                                                                                              year_to=year_to)))
    for entity in ENTITIES:
        display(Markdown('## {entity}'.format(entity=entity)))
        display_cumul_salary_change('San Mateo County', entity, year_from, year_to)

San Mateo County, Cumulative Mean Salary Change in 2012 - 2016

Teachers

Managers

Superintendents

In [5]:
# Mean salary

year_from = min(YEARS)
year_to = max(YEARS)

for county in COUNTIES:
    display(Markdown('# {county}, Mean Salary in {year_from} - {year_to}'.format(county=county,
                                                                                 year_from=year_from,
                                                                                 year_to=year_to)))
    for year in YEARS:
        display(Markdown('## {year}'.format(year=year)))
        
        for entity in ENTITIES:
            display(Markdown('### {entity}'.format(entity=entity)))
            display_mean_salary_by_year(county, entity, year)

San Mateo County, Mean Salary in 2012 - 2016

2016

Teachers

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 51.00 114,308.22 35,249.92 24,441.29 103,155.85 121,072.10 141,348.27 155,939.98
Las Lomitas Elementary 86.00 112,186.29 34,589.27 17,674.21 101,644.44 124,789.11 135,003.10 162,679.42
Menlo Park City Elementary 197.00 109,100.83 31,872.65 4,772.96 93,540.96 120,378.59 132,307.00 149,728.85
San Mateo Union High 516.00 89,637.90 55,348.64 0.00 43,487.97 110,342.98 136,326.11 177,103.02
Redwood City Elementary 414.00 84,091.86 30,399.76 3,467.76 66,821.58 90,014.50 108,050.12 130,262.17
San Mateo County Office of Education 98.00 81,386.74 51,924.93 161.00 34,584.75 87,253.00 130,387.50 162,407.00
San Mateo-Foster City 671.00 80,915.34 34,628.19 0.00 56,369.85 88,089.60 109,455.35 130,813.29
San Carlos Elementary 179.00 80,820.37 30,054.58 10,515.54 62,665.38 93,103.93 101,742.90 118,654.71
Belmont-Redwood Shores Elementary 212.00 80,434.73 30,277.63 1.00 63,843.00 84,095.00 104,613.75 141,135.00
Pacifica School District 166.00 78,638.99 31,585.52 0.00 56,373.25 88,943.20 105,053.93 126,200.80
South San Francisco Unified 361.00 76,595.15 26,264.21 0.00 65,551.00 79,782.00 96,918.00 127,910.00
Burlingame Elementary 184.00 74,049.30 27,328.24 4,156.15 54,526.63 77,799.64 96,986.45 116,783.89
Bayshore Elementary 23.00 71,390.65 24,179.92 23,153.00 64,017.00 76,141.00 85,656.50 102,482.00
La Honda-Pescadero Unified 38.00 66,915.00 30,181.64 24.70 47,218.51 72,050.93 87,400.46 124,795.88

Managers

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 31.00 188,238.37 57,809.14 71,660.30 171,328.46 187,869.99 214,945.49 348,435.74
Portola Valley Elementary 7.00 180,136.75 65,742.97 42,479.98 182,593.24 187,974.57 209,274.52 246,767.16
Menlo Park City Elementary 16.00 179,321.71 34,523.25 140,584.95 148,191.75 178,038.99 198,997.30 274,717.64
San Mateo-Foster City 41.00 166,990.78 46,817.76 43,060.05 160,921.63 185,196.75 192,755.11 270,074.32
Burlingame Elementary 16.00 162,261.77 40,885.78 111,612.22 141,249.74 153,092.38 175,045.06 293,857.48
San Mateo County Office of Education 19.00 156,921.00 69,794.49 307.00 137,576.50 167,977.00 194,805.50 272,407.00
Las Lomitas Elementary 12.00 151,795.77 51,351.00 64,856.23 120,715.84 162,376.71 178,368.52 248,142.92
Belmont-Redwood Shores Elementary 16.00 147,806.94 38,699.80 78,340.00 123,041.00 149,778.50 167,874.00 234,988.00
Pacifica School District 17.00 146,165.94 53,597.25 14,546.44 131,817.65 150,180.96 162,938.29 248,636.70
Redwood City Elementary 42.00 145,462.82 41,731.43 64,276.06 131,574.04 151,397.20 168,140.62 268,113.54
San Carlos Elementary 18.00 138,092.58 48,904.47 11,095.54 127,227.71 138,932.85 156,218.16 238,839.36
South San Francisco Unified 30.00 129,668.00 46,964.35 0.00 103,666.25 142,952.00 158,681.00 225,309.00
Bayshore Elementary 4.00 108,459.75 63,718.93 54,525.00 56,265.75 97,654.00 149,848.00 184,006.00
La Honda-Pescadero Unified 6.00 106,035.88 31,954.60 50,338.65 94,916.72 117,095.02 123,246.04 138,866.25

Superintendents

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 2.00 319,538.46 40,866.92 290,641.19 305,089.83 319,538.46 333,987.10 348,435.74
San Mateo-Foster City 1.00 270,074.32 nan 270,074.32 270,074.32 270,074.32 270,074.32 270,074.32
Redwood City Elementary 1.00 268,113.54 nan 268,113.54 268,113.54 268,113.54 268,113.54 268,113.54
Portola Valley Elementary 1.00 246,767.16 nan 246,767.16 246,767.16 246,767.16 246,767.16 246,767.16
Menlo Park City Elementary 2.00 243,201.23 44,570.94 211,684.81 227,443.02 243,201.23 258,959.43 274,717.64
San Mateo County Office of Education 5.00 229,732.20 26,019.06 204,120.00 215,341.00 225,221.00 231,572.00 272,407.00
Pacifica School District 2.00 224,064.61 34,750.18 199,492.52 211,778.57 224,064.61 236,350.66 248,636.70
Burlingame Elementary 3.00 221,090.65 63,018.18 184,528.35 184,707.23 184,886.11 239,371.79 293,857.48
San Carlos Elementary 2.00 211,754.71 38,303.48 184,670.06 198,212.38 211,754.71 225,297.03 238,839.36
Bayshore Elementary 1.00 184,006.00 nan 184,006.00 184,006.00 184,006.00 184,006.00 184,006.00
Belmont-Redwood Shores Elementary 2.00 175,290.50 84,425.01 115,593.00 145,441.75 175,290.50 205,139.25 234,988.00
South San Francisco Unified 3.00 169,704.00 66,012.77 96,749.00 141,901.50 187,054.00 206,181.50 225,309.00
Las Lomitas Elementary 2.00 164,871.74 117,763.23 81,600.56 123,236.15 164,871.74 206,507.33 248,142.92
La Honda-Pescadero Unified 2.00 113,445.35 35,950.58 88,024.45 100,734.90 113,445.35 126,155.80 138,866.25

2015

Teachers

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 388.00 117,053.42 38,169.12 1,199.06 97,240.68 129,096.21 146,170.96 195,573.51
Menlo Park City Elementary 210.00 106,634.16 38,686.06 1,314.29 85,142.04 121,874.85 136,013.63 152,600.47
Woodside Elementary 39.00 105,741.35 32,786.61 35,032.81 85,672.04 115,348.25 127,850.42 165,303.09
Hillsborough City Elementary 135.00 105,162.21 36,274.90 14,200.68 82,639.96 117,400.88 132,841.88 156,858.61
San Carlos Elementary 180.00 83,407.44 27,958.95 466.41 71,778.05 93,333.76 103,788.60 120,869.68
San Mateo-Foster City 629.00 83,212.40 29,649.92 0.00 66,751.62 90,426.97 106,376.27 130,413.40
Cabrillo Unified 184.00 81,777.17 34,833.83 881.28 62,324.38 85,248.49 110,965.51 151,335.71
South San Francisco Unified 462.00 79,156.75 26,248.53 7,958.79 66,955.60 84,441.05 100,269.82 134,160.62
Jefferson Elementary 352.00 78,553.44 29,733.54 1,159.30 62,450.78 85,683.54 101,899.68 130,453.74
Las Lomitas Elementary 147.00 76,413.64 60,059.38 0.00 5,274.05 96,178.84 131,790.18 164,809.81
Pacifica School District 167.00 74,941.96 32,807.89 279.69 44,251.46 84,648.41 102,492.52 124,831.43
Millbrae Elementary 145.00 72,698.63 31,377.97 1,219.43 42,626.00 78,673.19 100,827.27 122,979.02
La Honda-Pescadero Unified 37.00 72,450.63 33,348.15 66.35 60,311.79 80,146.95 92,991.62 129,516.80
Belmont-Redwood Shores Elementary 293.00 62,663.58 44,117.38 75.50 17,713.82 70,308.95 101,781.41 138,947.88
Redwood City Elementary 683.00 58,250.73 40,445.78 0.00 18,701.51 59,961.68 97,720.35 127,244.90
Bayshore Elementary 26.00 57,759.40 28,857.41 3,612.80 34,075.67 65,248.93 75,227.95 103,615.24
Burlingame Elementary 289.00 52,548.26 39,689.07 0.00 10,129.91 52,903.21 91,831.64 115,200.73

Managers

count mean std min 25% 50% 75% max
Agency
Hillsborough City Elementary 9.00 180,800.32 48,691.11 89,546.44 178,676.13 188,815.96 201,455.00 253,150.62
San Mateo Union High 35.00 179,364.51 51,950.72 83,158.91 157,897.61 184,304.04 212,086.15 330,816.69
Las Lomitas Elementary 12.00 164,175.26 52,042.13 64,807.13 138,380.98 179,541.06 195,614.17 235,632.38
San Mateo-Foster City 39.00 163,547.65 40,346.02 55,680.49 151,279.98 182,760.17 188,471.58 209,969.37
Burlingame Elementary 15.00 163,290.94 55,282.29 60,098.64 153,580.73 163,974.68 183,922.66 300,712.30
Woodside Elementary 8.00 152,223.30 62,430.85 96,975.96 102,800.28 148,727.36 165,407.88 287,480.51
San Carlos Elementary 16.00 151,139.11 40,843.87 65,947.53 135,040.70 150,910.72 163,008.67 246,861.84
Menlo Park City Elementary 20.00 146,769.11 72,683.67 1,320.89 84,959.91 166,267.17 200,791.70 269,385.57
Pacifica School District 16.00 143,586.61 51,778.18 49,589.52 117,958.86 148,467.15 170,896.62 237,194.10
Redwood City Elementary 39.00 140,820.04 44,175.73 14,975.72 131,887.54 152,557.36 164,632.14 223,152.08
Belmont-Redwood Shores Elementary 17.00 140,485.69 61,757.17 1,480.75 138,942.98 164,994.56 173,561.04 233,844.88
South San Francisco Unified 32.00 132,642.32 37,510.74 37,939.40 124,617.19 143,527.35 151,413.09 205,408.48
Jefferson Elementary 32.00 132,317.99 47,399.81 11,055.74 110,352.53 150,614.30 156,865.38 244,588.82
La Honda-Pescadero Unified 5.00 130,490.52 10,691.32 118,325.88 122,842.13 129,516.80 136,776.02 144,991.75
Cabrillo Unified 20.00 126,984.94 37,431.22 57,603.29 96,715.65 134,913.92 147,660.61 200,071.38
Millbrae Elementary 14.00 114,471.56 51,463.79 48,777.38 61,762.23 123,167.40 152,566.90 185,831.11
Bayshore Elementary 4.00 85,788.06 34,855.37 56,680.98 61,627.81 76,491.23 100,651.48 133,488.81

Superintendents

count mean std min 25% 50% 75% max
Agency
Woodside Elementary 1.00 287,480.51 nan 287,480.51 287,480.51 287,480.51 287,480.51 287,480.51
Hillsborough City Elementary 1.00 253,150.62 nan 253,150.62 253,150.62 253,150.62 253,150.62 253,150.62
San Mateo Union High 3.00 242,229.10 77,920.68 184,304.04 197,935.30 211,566.56 271,191.62 330,816.69
Menlo Park City Elementary 2.00 241,436.48 39,525.98 213,487.40 227,461.94 241,436.48 255,411.03 269,385.57
Las Lomitas Elementary 1.00 235,632.38 nan 235,632.38 235,632.38 235,632.38 235,632.38 235,632.38
Burlingame Elementary 3.00 227,565.73 63,431.13 187,722.55 190,992.44 194,262.33 247,487.32 300,712.30
San Carlos Elementary 2.00 217,249.02 41,878.86 187,636.19 202,442.60 217,249.02 232,055.43 246,861.84
Pacifica School District 2.00 211,077.69 36,934.18 184,961.28 198,019.48 211,077.69 224,135.90 237,194.10
Redwood City Elementary 2.00 177,061.68 65,181.67 130,971.28 154,016.48 177,061.68 200,106.88 223,152.08
Jefferson Elementary 4.00 174,835.87 58,363.09 101,801.80 155,829.31 176,476.42 195,482.97 244,588.82
South San Francisco Unified 4.00 169,479.33 25,143.86 151,963.97 152,162.23 160,272.43 177,589.52 205,408.48
Millbrae Elementary 2.00 147,157.88 50,309.66 111,583.57 129,370.72 147,157.88 164,945.03 182,732.18
La Honda-Pescadero Unified 1.00 144,991.75 nan 144,991.75 144,991.75 144,991.75 144,991.75 144,991.75
San Mateo-Foster City 1.00 122,130.64 nan 122,130.64 122,130.64 122,130.64 122,130.64 122,130.64
Cabrillo Unified 5.00 120,942.59 34,903.87 83,882.00 108,345.55 108,645.35 126,715.60 177,124.43
Belmont-Redwood Shores Elementary 3.00 116,929.98 115,045.04 3,850.73 58,472.53 113,094.34 173,469.61 233,844.88
Bayshore Elementary 1.00 89,705.70 nan 89,705.70 89,705.70 89,705.70 89,705.70 89,705.70

2014

Teachers

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 52.00 105,835.64 37,843.49 19,043.07 84,528.15 118,646.98 136,825.63 150,799.05
San Mateo Union High 416.00 103,967.96 39,288.93 0.00 79,755.12 116,578.34 134,148.12 174,815.47
Menlo Park City Elementary 186.00 100,413.68 29,965.09 11,063.51 84,839.62 111,633.74 122,127.92 155,511.51
Hillsborough City Elementary 121.00 100,334.02 32,384.40 2,340.89 84,872.43 112,626.72 124,116.39 143,246.43
San Mateo County Office of Education 103.00 87,739.74 39,363.82 395.31 66,196.79 107,152.76 119,103.05 136,965.99
Jefferson Elementary 332.00 76,217.28 25,110.28 3,763.12 63,432.53 82,794.68 95,520.44 119,883.27
Belmont-Redwood Shores Elementary 217.00 74,392.10 30,452.18 3,774.79 49,936.49 80,745.93 100,871.89 126,241.04
Redwood City Elementary 495.00 74,273.03 30,093.96 351.67 48,675.15 77,395.72 99,867.10 121,788.88
Brisbane Elementary 37.00 73,454.80 28,064.80 11,053.65 50,678.81 85,438.75 94,788.67 118,708.63
Pacifica School District 165.00 73,329.55 31,912.64 678.11 44,900.92 83,471.82 100,356.14 121,840.67
Ravenswood City Elementary 197.00 71,128.68 25,138.88 0.00 56,524.67 73,807.54 88,427.73 115,228.80
Millbrae Elementary 139.00 71,015.98 30,785.37 17.22 46,388.65 78,047.89 96,976.98 119,780.36
Las Lomitas Elementary 148.00 69,855.70 53,581.00 160.59 7,628.11 78,512.02 120,401.01 150,214.89
San Carlos Elementary 166.00 67,331.71 20,636.47 7,099.70 56,748.88 72,876.01 81,953.33 92,283.37
Jefferson Union High 307.00 67,162.87 36,646.41 787.85 36,045.01 73,695.53 96,644.91 139,596.81
San Bruno Park Elementary 127.00 67,075.63 22,418.21 10,196.68 54,798.21 72,355.32 83,035.36 102,585.78
San Mateo-Foster City 689.00 66,616.08 39,514.74 0.00 29,700.67 74,407.94 98,813.28 146,467.25
La Honda-Pescadero Unified 39.00 65,014.45 30,052.89 12,498.98 37,932.88 63,799.98 91,097.86 111,784.48
Burlingame Elementary 300.00 47,605.96 39,188.40 66.00 3,930.75 47,564.80 84,949.23 109,924.81

Managers

count mean std min 25% 50% 75% max
Agency
Hillsborough City Elementary 9.00 181,169.81 31,783.70 111,214.08 177,599.65 179,517.22 192,084.61 230,110.31
San Mateo Union High 34.00 179,583.06 63,800.06 67,855.19 146,944.32 193,358.54 214,268.96 349,292.66
San Mateo County Office of Education 15.00 171,824.75 42,039.61 112,399.23 154,657.73 160,899.90 192,750.15 269,154.10
Las Lomitas Elementary 11.00 169,416.52 36,724.89 87,928.76 157,297.48 180,683.39 184,717.90 222,583.06
Portola Valley Elementary 6.00 154,655.21 68,101.01 43,745.94 119,738.83 181,106.54 197,847.62 219,261.33
Burlingame Elementary 14.00 147,353.48 46,239.63 85,085.58 128,919.51 150,926.52 160,606.88 269,387.20
Menlo Park City Elementary 17.00 144,489.42 53,016.32 21,375.38 127,400.90 156,662.77 175,083.73 237,957.52
San Mateo-Foster City 44.00 142,133.09 51,832.37 3,285.24 138,346.99 159,025.19 164,019.51 295,265.20
Pacifica School District 15.00 142,035.24 48,802.13 54,837.09 123,938.61 152,575.98 162,585.12 229,580.87
Belmont-Redwood Shores Elementary 14.00 135,555.77 43,988.69 62,544.65 117,238.43 143,240.91 152,731.18 230,557.28
Redwood City Elementary 43.00 129,560.79 48,787.56 863.21 120,327.95 144,624.91 157,269.14 229,521.57
Ravenswood City Elementary 22.00 124,625.58 35,159.64 64,941.02 115,191.43 133,356.90 139,483.53 219,733.88
Jefferson Elementary 32.00 118,060.53 48,631.02 10,085.22 76,929.27 138,715.01 143,836.44 225,706.35
San Carlos Elementary 15.00 116,900.91 22,790.03 72,134.56 108,930.33 117,762.96 124,632.11 171,667.00
Jefferson Union High 30.00 114,744.61 53,042.96 489.14 73,619.18 131,492.35 149,925.63 225,689.78
La Honda-Pescadero Unified 5.00 109,192.75 8,997.91 100,878.14 101,856.17 105,995.60 116,063.53 121,170.31
San Bruno Park Elementary 12.00 97,827.48 27,878.94 30,670.58 86,900.54 103,920.21 106,481.04 147,856.33
Millbrae Elementary 15.00 96,670.52 62,496.14 328.69 49,454.32 94,317.80 142,291.30 209,097.50
Brisbane Elementary 6.00 86,987.40 66,854.66 2,191.88 50,682.93 79,517.39 112,352.65 196,328.58

Superintendents

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 3.00 296,204.93 47,582.96 257,396.97 269,661.06 281,925.15 315,608.91 349,292.66
San Mateo-Foster City 1.00 295,265.20 nan 295,265.20 295,265.20 295,265.20 295,265.20 295,265.20
Menlo Park City Elementary 1.00 237,957.52 nan 237,957.52 237,957.52 237,957.52 237,957.52 237,957.52
Hillsborough City Elementary 1.00 230,110.31 nan 230,110.31 230,110.31 230,110.31 230,110.31 230,110.31
San Mateo County Office of Education 5.00 216,476.90 31,660.57 192,543.96 192,956.34 206,971.77 220,758.31 269,154.10
Millbrae Elementary 1.00 209,097.50 nan 209,097.50 209,097.50 209,097.50 209,097.50 209,097.50
Pacifica School District 2.00 202,644.54 38,093.73 175,708.20 189,176.37 202,644.54 216,112.70 229,580.87
Redwood City Elementary 3.00 197,373.02 30,135.73 169,765.51 181,298.74 192,831.98 211,176.78 229,521.57
Jefferson Elementary 3.00 190,597.15 33,143.64 159,851.30 173,042.55 186,233.80 205,970.08 225,706.35
Belmont-Redwood Shores Elementary 3.00 175,930.99 57,906.98 115,223.32 148,617.85 182,012.37 206,284.83 230,557.28
Burlingame Elementary 4.00 155,992.73 84,868.02 88,124.54 92,392.36 133,229.59 196,829.96 269,387.20
Las Lomitas Elementary 2.00 155,255.91 95,214.97 87,928.76 121,592.33 155,255.91 188,919.48 222,583.06
San Carlos Elementary 2.00 153,833.50 25,220.38 136,000.00 144,916.75 153,833.50 162,750.25 171,667.00
San Bruno Park Elementary 1.00 147,856.33 nan 147,856.33 147,856.33 147,856.33 147,856.33 147,856.33
Ravenswood City Elementary 4.00 147,572.45 58,114.58 77,512.55 127,282.01 146,521.69 166,812.13 219,733.88
Brisbane Elementary 2.00 143,652.97 74,494.56 90,977.36 117,315.17 143,652.97 169,990.77 196,328.58
Jefferson Union High 6.00 143,612.26 67,642.88 30,418.29 118,954.05 159,840.73 175,379.33 225,689.78
La Honda-Pescadero Unified 1.00 121,170.31 nan 121,170.31 121,170.31 121,170.31 121,170.31 121,170.31
Portola Valley Elementary 1.00 43,745.94 nan 43,745.94 43,745.94 43,745.94 43,745.94 43,745.94

2013

Teachers

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 438.00 106,746.38 32,364.59 6,441.78 91,408.80 118,055.93 130,396.84 168,120.68
Menlo Park City Elementary 185.00 105,104.41 30,059.19 24,090.59 94,554.82 115,788.83 126,987.88 153,199.80
Portola Valley Elementary 51.00 100,642.73 32,682.52 27,403.30 83,698.24 111,475.08 127,329.18 142,243.51
Woodside Elementary 42.00 91,489.52 35,015.90 27,239.60 61,736.57 105,456.31 119,330.60 153,219.27
Sequoia Union High 561.00 90,095.17 42,362.88 137.12 53,709.96 103,786.26 125,135.60 156,745.76
San Mateo County Office of Education 107.00 86,761.85 43,038.56 172.39 46,162.77 108,267.94 119,327.44 136,325.97
Brisbane Elementary 31.00 77,818.67 18,070.36 18,839.57 71,261.17 81,433.83 87,380.96 105,451.17
San Carlos Elementary 161.00 76,820.16 25,046.03 10,598.42 63,564.87 82,375.41 97,196.71 112,622.01
Redwood City Elementary 449.00 75,288.02 25,819.08 1,834.92 60,152.63 81,916.51 96,344.24 116,783.84
Cabrillo Unified 183.00 75,205.05 36,026.07 110.00 49,244.57 87,243.61 104,155.54 142,403.74
Belmont-Redwood Shores Elementary 205.00 73,109.07 30,021.01 2,665.76 59,466.52 80,115.69 97,904.88 123,762.26
Jefferson Elementary 305.00 71,644.48 21,574.01 4,925.83 58,902.86 77,942.15 88,039.29 109,289.78
San Mateo-Foster City 602.00 71,214.45 26,121.34 583.81 57,438.85 77,823.61 91,047.58 112,736.83
Las Lomitas Elementary 143.00 70,782.84 54,023.51 95.44 7,836.59 81,882.30 122,727.04 152,121.77
South San Francisco Unified 468.00 70,256.05 24,695.86 958.73 60,398.03 75,477.73 89,180.58 122,537.33
Pacifica School District 161.00 70,103.76 28,779.30 4,844.49 53,541.39 78,631.27 93,947.82 114,053.43
Millbrae Elementary 126.00 69,823.92 27,954.43 5,995.26 52,522.74 79,981.64 94,162.41 112,745.96
Burlingame Elementary 174.00 68,961.49 26,729.16 16,394.88 46,036.80 74,302.80 91,756.54 112,808.86
Ravenswood City Elementary 213.00 65,991.92 26,802.79 2,211.88 41,526.00 71,886.56 85,880.97 111,852.33
Hillsborough City Elementary 200.00 57,354.30 48,936.88 67.50 2,530.37 55,736.11 108,284.97 140,377.22
Jefferson Union High 320.00 55,105.38 37,056.50 3.64 16,885.65 64,265.88 86,367.07 125,814.87
La Honda-Pescadero Unified 42.00 51,679.88 30,051.52 1,745.12 26,156.20 53,969.84 74,093.12 108,244.30
Bayshore Elementary 33.00 39,379.46 31,633.67 135.31 5,022.80 33,913.54 63,776.90 97,785.69

Managers

count mean std min 25% 50% 75% max
Agency
San Mateo Union High 29.00 174,610.09 37,344.00 65,133.59 163,524.10 178,442.24 187,430.04 258,306.10
Menlo Park City Elementary 13.00 152,274.04 55,485.92 18,852.54 143,425.06 150,900.46 185,098.21 245,983.71
Las Lomitas Elementary 10.00 151,517.41 51,373.59 23,094.62 151,314.22 166,578.73 175,308.22 213,357.76
Hillsborough City Elementary 11.00 149,780.55 45,589.32 82,671.33 117,504.30 164,223.51 175,083.02 228,250.83
Sequoia Union High 21.00 149,521.13 59,225.92 5,816.90 142,494.62 166,466.97 183,608.11 253,867.20
San Mateo County Office of Education 16.00 147,809.64 56,417.21 29,261.07 107,509.12 151,154.52 185,551.14 240,595.31
San Mateo-Foster City 36.00 145,454.55 36,159.08 58,301.25 138,502.51 150,877.10 155,011.22 282,214.43
Woodside Elementary 6.00 138,135.42 67,761.08 41,176.92 100,659.11 145,226.73 168,350.56 235,320.41
Pacifica School District 13.00 137,986.12 40,797.00 48,149.41 124,462.58 136,397.32 155,031.49 211,025.07
Burlingame Elementary 12.00 130,820.46 57,985.23 52,437.15 78,320.53 145,302.76 151,915.66 250,942.90
South San Francisco Unified 34.00 127,547.12 29,951.53 54,590.37 117,912.68 125,232.95 140,487.06 226,915.94
Jefferson Elementary 27.00 124,934.87 27,088.22 50,362.61 115,391.39 124,849.65 135,243.35 202,870.52
Jefferson Union High 24.00 119,422.92 32,177.16 34,969.11 104,889.84 119,926.77 134,103.14 202,264.92
San Carlos Elementary 15.00 119,201.79 45,586.65 28,793.78 95,778.90 132,528.30 139,505.67 216,285.71
Ravenswood City Elementary 24.00 118,728.53 35,708.23 43,308.32 104,135.26 124,797.54 141,064.19 177,308.07
Belmont-Redwood Shores Elementary 19.00 118,533.85 38,676.60 66,349.20 87,152.72 114,703.60 144,310.93 219,341.77
Redwood City Elementary 42.00 116,009.93 38,733.86 34,401.89 84,208.47 124,649.43 145,017.41 222,483.60
Bayshore Elementary 2.00 114,167.58 1,071.69 113,409.78 113,788.68 114,167.58 114,546.48 114,925.38
Millbrae Elementary 12.00 104,993.60 55,724.13 30,219.41 49,558.56 125,105.88 129,884.47 208,543.22
Brisbane Elementary 4.00 104,810.08 74,776.69 19,635.50 69,039.40 99,802.46 135,573.14 199,999.89
Portola Valley Elementary 5.00 97,005.25 56,071.15 32,480.14 86,928.95 89,070.58 89,070.58 187,476.00
Cabrillo Unified 23.00 92,846.36 58,925.94 132.00 48,843.62 99,992.67 139,522.17 212,956.80
La Honda-Pescadero Unified 4.00 92,784.33 13,539.53 80,864.83 86,600.29 89,011.26 95,195.30 112,249.99

Superintendents

count mean std min 25% 50% 75% max
Agency
San Mateo-Foster City 1.00 282,214.43 nan 282,214.43 282,214.43 282,214.43 282,214.43 282,214.43
Sequoia Union High 1.00 253,867.20 nan 253,867.20 253,867.20 253,867.20 253,867.20 253,867.20
Menlo Park City Elementary 1.00 245,983.71 nan 245,983.71 245,983.71 245,983.71 245,983.71 245,983.71
San Mateo Union High 3.00 238,390.98 33,790.30 199,376.14 228,433.42 257,490.69 257,898.40 258,306.10
Woodside Elementary 1.00 235,320.41 nan 235,320.41 235,320.41 235,320.41 235,320.41 235,320.41
Hillsborough City Elementary 1.00 228,250.83 nan 228,250.83 228,250.83 228,250.83 228,250.83 228,250.83
San Carlos Elementary 1.00 216,285.71 nan 216,285.71 216,285.71 216,285.71 216,285.71 216,285.71
San Mateo County Office of Education 5.00 205,128.46 22,470.00 184,321.69 189,239.48 199,595.98 211,889.86 240,595.31
Redwood City Elementary 2.00 200,482.88 31,113.72 178,482.16 189,482.52 200,482.88 211,483.24 222,483.60
Jefferson Elementary 2.00 183,623.54 27,219.33 164,376.57 174,000.06 183,623.54 193,247.03 202,870.52
Pacifica School District 2.00 183,028.28 39,593.44 155,031.49 169,029.89 183,028.28 197,026.67 211,025.07
South San Francisco Unified 4.00 182,013.99 30,112.35 163,849.77 165,280.11 168,645.12 185,379.01 226,915.94
Burlingame Elementary 3.00 172,084.90 84,974.36 82,092.05 132,655.90 183,219.75 217,081.33 250,942.90
Jefferson Union High 5.00 143,455.95 50,730.40 64,076.40 141,702.48 142,734.55 166,501.38 202,264.92
Brisbane Elementary 2.00 142,753.63 80,958.44 85,507.37 114,130.50 142,753.63 171,376.76 199,999.89
Belmont-Redwood Shores Elementary 4.00 140,034.66 53,341.11 108,009.34 108,920.61 116,393.77 147,507.83 219,341.77
Ravenswood City Elementary 6.00 128,929.19 38,630.81 67,620.40 111,012.66 134,809.36 150,662.99 177,308.07
Cabrillo Unified 5.00 119,802.87 79,135.06 140.00 93,829.21 145,439.40 146,648.94 212,956.80
Las Lomitas Elementary 2.00 118,226.19 134,536.36 23,094.62 70,660.40 118,226.19 165,791.98 213,357.76
La Honda-Pescadero Unified 1.00 112,249.99 nan 112,249.99 112,249.99 112,249.99 112,249.99 112,249.99
Millbrae Elementary 3.00 111,146.49 85,136.62 50,887.38 62,448.12 74,008.86 141,276.04 208,543.22
Portola Valley Elementary 1.00 86,928.95 nan 86,928.95 86,928.95 86,928.95 86,928.95 86,928.95

2012

Teachers

count mean std min 25% 50% 75% max
Agency
Redwood City Elementary 1.00 106,291.19 nan 106,291.19 106,291.19 106,291.19 106,291.19 106,291.19
Portola Valley Elementary 51.00 103,730.36 36,416.99 12,196.40 82,261.15 116,476.30 131,327.46 147,461.64
San Mateo Union High 448.00 102,353.30 32,984.91 219.40 85,361.62 114,449.71 126,636.85 161,873.28
Menlo Park City Elementary 175.00 98,317.48 27,246.94 16,259.12 86,321.99 107,683.84 118,193.43 138,092.83
Sequoia Union High 463.00 97,190.92 31,663.12 2,369.70 76,728.01 106,057.00 121,067.18 152,706.34
San Mateo County Office of Education 107.00 82,472.19 39,042.44 1,442.17 61,257.54 101,141.14 112,090.66 125,511.89
Belmont-Redwood Shores Elementary 192.00 75,600.08 29,794.20 389.37 61,106.56 82,535.86 100,154.55 120,567.44
Millbrae Elementary 118.00 73,237.94 25,669.15 1,129.65 59,877.69 82,400.92 93,143.48 110,617.36
South San Francisco Unified 475.00 71,240.39 23,378.12 3,571.38 61,071.07 75,791.69 89,006.58 123,700.60
Jefferson Elementary 294.00 70,895.21 20,457.99 8.75 59,641.22 76,396.02 86,299.99 104,356.13
Pacifica School District 1.00 68,010.68 nan 68,010.68 68,010.68 68,010.68 68,010.68 68,010.68
Burlingame Elementary 168.00 67,966.89 23,658.30 124.49 52,334.50 72,235.18 88,342.05 105,432.58
Las Lomitas Elementary 140.00 66,225.80 52,224.62 121.74 4,074.07 76,045.21 117,819.40 143,552.72
San Mateo-Foster City 582.00 65,746.56 24,875.46 5,265.89 47,096.58 72,331.05 86,252.96 104,866.65
Jefferson Union High 254.00 64,031.08 23,561.85 22.25 50,859.10 67,971.27 81,681.20 121,476.34
Ravenswood City Elementary 212.00 58,770.82 25,177.61 154.22 36,492.71 65,393.61 77,108.40 100,902.64
Hillsborough City Elementary 197.00 57,593.77 48,096.59 60.00 2,617.60 65,825.39 106,352.10 136,499.81
Woodside Elementary 69.00 56,385.01 49,752.68 159.06 2,505.80 57,991.67 104,225.30 145,463.08
San Carlos Elementary 229.00 56,255.93 39,349.96 43.71 9,461.09 68,216.61 91,471.21 114,395.08
La Honda-Pescadero Unified 37.00 53,344.68 27,025.29 2,578.48 31,291.49 61,565.28 70,151.45 97,885.36
Bayshore Elementary 30.00 39,795.12 31,961.47 125.00 2,765.62 49,401.62 65,832.02 95,778.24

Managers

count mean std min 25% 50% 75% max
Agency
Portola Valley Elementary 3.00 196,362.47 18,333.60 182,528.68 185,965.17 189,401.66 203,279.36 217,157.07
Woodside Elementary 3.00 175,041.88 45,183.77 138,713.16 149,744.42 160,775.68 193,206.23 225,636.79
San Mateo Union High 30.00 173,871.02 39,811.63 42,959.22 159,690.79 178,330.42 187,605.56 256,250.04
Sequoia Union High 13.00 166,950.48 36,371.65 89,080.97 146,889.63 173,254.39 182,101.45 247,151.76
San Mateo County Office of Education 13.00 155,722.93 37,554.85 80,678.60 140,504.79 160,898.33 175,217.87 225,169.08
Menlo Park City Elementary 12.00 153,029.81 44,490.77 77,499.89 128,323.10 160,746.95 179,149.77 239,775.73
Burlingame Elementary 11.00 137,997.87 49,220.68 53,570.02 138,168.42 139,949.19 152,714.24 235,077.69
Hillsborough City Elementary 12.00 134,573.83 47,211.22 60,812.68 92,941.60 151,601.88 161,392.72 221,387.78
Millbrae Elementary 9.00 133,744.92 38,292.60 57,249.90 125,513.55 132,357.43 148,152.90 200,738.98
Belmont-Redwood Shores Elementary 16.00 131,621.45 42,031.48 57,996.80 102,749.76 143,481.64 158,409.88 204,954.78
Jefferson Elementary 23.00 120,422.29 27,386.57 37,805.39 111,583.60 119,928.13 128,084.18 193,615.91
Ravenswood City Elementary 20.00 113,298.29 33,958.73 23,336.36 101,309.19 117,317.07 124,494.35 195,853.86
South San Francisco Unified 35.00 112,020.05 34,741.47 44,560.16 98,284.98 117,120.98 130,195.55 208,827.57
Las Lomitas Elementary 13.00 110,235.79 48,377.67 16,877.43 78,674.18 106,692.60 156,093.40 171,198.28
San Mateo-Foster City 36.00 110,072.34 35,378.78 34,513.53 105,150.94 119,372.88 122,299.48 234,083.11
San Carlos Elementary 15.00 109,776.44 52,289.83 3,403.92 102,270.49 121,359.87 133,254.85 213,404.86
Bayshore Elementary 2.00 108,843.26 1,063.59 108,091.19 108,467.23 108,843.26 109,219.30 109,595.34
Jefferson Union High 31.00 90,777.02 37,540.64 11,790.66 58,088.41 94,270.92 116,867.35 188,310.28
La Honda-Pescadero Unified 7.00 77,049.86 33,199.20 11,674.89 69,059.82 85,020.75 98,251.76 108,030.18

Superintendents

count mean std min 25% 50% 75% max
Agency
Sequoia Union High 1.00 247,151.76 nan 247,151.76 247,151.76 247,151.76 247,151.76 247,151.76
San Mateo-Foster City 1.00 234,083.11 nan 234,083.11 234,083.11 234,083.11 234,083.11 234,083.11
San Mateo Union High 4.00 230,625.29 29,103.18 193,249.36 214,840.83 236,500.89 252,285.35 256,250.04
Woodside Elementary 1.00 225,636.79 nan 225,636.79 225,636.79 225,636.79 225,636.79 225,636.79
Hillsborough City Elementary 1.00 221,387.78 nan 221,387.78 221,387.78 221,387.78 221,387.78 221,387.78
Portola Valley Elementary 1.00 217,157.07 nan 217,157.07 217,157.07 217,157.07 217,157.07 217,157.07
San Carlos Elementary 1.00 213,404.86 nan 213,404.86 213,404.86 213,404.86 213,404.86 213,404.86
Menlo Park City Elementary 2.00 209,161.91 43,294.48 178,548.09 193,855.00 209,161.91 224,468.82 239,775.73
Millbrae Elementary 1.00 200,738.98 nan 200,738.98 200,738.98 200,738.98 200,738.98 200,738.98
San Mateo County Office of Education 5.00 188,638.23 24,029.25 161,722.01 175,217.87 184,915.87 196,166.34 225,169.08
Burlingame Elementary 3.00 188,365.39 40,581.49 161,795.59 165,009.23 168,222.88 201,650.29 235,077.69
Jefferson Elementary 2.00 173,525.42 28,412.24 153,434.93 163,480.17 173,525.42 183,570.66 193,615.91
South San Francisco Unified 4.00 156,671.99 39,689.03 112,415.30 140,551.02 152,722.54 168,843.52 208,827.57
Ravenswood City Elementary 3.00 155,942.76 34,667.09 133,316.02 135,987.21 138,658.40 167,256.13 195,853.86
Belmont-Redwood Shores Elementary 4.00 150,244.52 47,646.82 109,660.76 110,668.93 143,181.27 182,756.86 204,954.78
Jefferson Union High 6.00 116,717.11 59,560.41 11,790.66 104,079.25 128,001.29 143,070.73 188,310.28
La Honda-Pescadero Unified 1.00 108,030.18 nan 108,030.18 108,030.18 108,030.18 108,030.18 108,030.18
Las Lomitas Elementary 3.00 104,582.00 24,919.65 78,674.18 92,683.39 106,692.60 117,535.91 128,379.22